select nsp_id,
lpad(' ',(level-1) *4) ||  nsp_name
 from namespace
connect by prior nsp_Id = nsp_parent_nsp_Id
start with nsp_parent_nsp_Id is null